Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	6156
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	1
Duplicate rows (%)	< 0.1%
Total size in memory	721.5 KiB
Average record size in memory	120.0 B

Variable types

Numeric	15

Alerts

Dataset has 1 (< 0.1%) duplicate rows	Duplicates
`employee_payroll` is highly correlated with `bad_dept_expence` and 7 other fields	High correlation
`charity_care` is highly correlated with `bad_dept_expence` and 1 other fields	High correlation
`bad_dept_expence` is highly correlated with `employee_payroll` and 4 other fields	High correlation
`unreimbursed_and_uncompensated` is highly correlated with `employee_payroll` and 6 other fields	High correlation
`Total Costs` is highly correlated with `employee_payroll` and 6 other fields	High correlation
`outpatient_inpatient_charges` is highly correlated with `employee_payroll` and 7 other fields	High correlation
`Contract Labor` is highly correlated with `discharge_payments`	High correlation
`account_receivable` is highly correlated with `employee_payroll` and 5 other fields	High correlation
`assets` is highly correlated with `employee_payroll` and 6 other fields	High correlation
`account_payable` is highly correlated with `employee_payroll` and 5 other fields	High correlation
`discharge_payments` is highly correlated with `Contract Labor`	High correlation
`gross_revenue` is highly correlated with `employee_payroll` and 7 other fields	High correlation
`employee_payroll` is highly correlated with `bad_dept_expence` and 8 other fields	High correlation
`charity_care` is highly correlated with `bad_dept_expence` and 1 other fields	High correlation
`bad_dept_expence` is highly correlated with `employee_payroll` and 5 other fields	High correlation
`unreimbursed_and_uncompensated` is highly correlated with `employee_payroll` and 6 other fields	High correlation
`Total Costs` is highly correlated with `employee_payroll` and 8 other fields	High correlation
`outpatient_inpatient_charges` is highly correlated with `employee_payroll` and 8 other fields	High correlation
`total_salaries` is highly correlated with `employee_payroll` and 6 other fields	High correlation
`account_receivable` is highly correlated with `employee_payroll` and 5 other fields	High correlation
`assets` is highly correlated with `employee_payroll` and 5 other fields	High correlation
`account_payable` is highly correlated with `assets`	High correlation
`discharge_payments` is highly correlated with `employee_payroll` and 4 other fields	High correlation
`gross_revenue` is highly correlated with `employee_payroll` and 8 other fields	High correlation
`employee_payroll` is highly correlated with `Total Costs` and 5 other fields	High correlation
`charity_care` is highly correlated with `bad_dept_expence` and 1 other fields	High correlation
`bad_dept_expence` is highly correlated with `charity_care` and 1 other fields	High correlation
`unreimbursed_and_uncompensated` is highly correlated with `charity_care` and 1 other fields	High correlation
`Total Costs` is highly correlated with `employee_payroll` and 5 other fields	High correlation
`outpatient_inpatient_charges` is highly correlated with `employee_payroll` and 5 other fields	High correlation
`account_receivable` is highly correlated with `employee_payroll` and 5 other fields	High correlation
`assets` is highly correlated with `employee_payroll` and 5 other fields	High correlation
`account_payable` is highly correlated with `employee_payroll` and 5 other fields	High correlation
`gross_revenue` is highly correlated with `employee_payroll` and 5 other fields	High correlation
`employee_payroll` is highly correlated with `bad_dept_expence` and 9 other fields	High correlation
`charity_care` is highly correlated with `bad_dept_expence` and 2 other fields	High correlation
`bad_dept_expence` is highly correlated with `employee_payroll` and 2 other fields	High correlation
`unreimbursed_and_uncompensated` is highly correlated with `employee_payroll` and 10 other fields	High correlation
`Total Costs` is highly correlated with `employee_payroll` and 10 other fields	High correlation
`outpatient_inpatient_charges` is highly correlated with `employee_payroll` and 9 other fields	High correlation
`total_salaries` is highly correlated with `employee_payroll` and 8 other fields	High correlation
`Contract Labor` is highly correlated with `net_income`	High correlation
`cash` is highly correlated with `charity_care` and 5 other fields	High correlation
`account_receivable` is highly correlated with `employee_payroll` and 8 other fields	High correlation
`assets` is highly correlated with `employee_payroll` and 10 other fields	High correlation
`account_payable` is highly correlated with `employee_payroll` and 5 other fields	High correlation
`discharge_payments` is highly correlated with `employee_payroll` and 8 other fields	High correlation
`gross_revenue` is highly correlated with `employee_payroll` and 9 other fields	High correlation
`net_income` is highly correlated with `unreimbursed_and_uncompensated` and 6 other fields	High correlation
`charity_care` is highly skewed (γ1 = 22.06018491)	Skewed

Reproduction

Analysis started	2022-02-09 20:31:45.368752
Analysis finished	2022-02-09 20:32:18.024090
Duration	32.66 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

employee_payroll
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	5753
Distinct (%)	93.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	846.0510883

Minimum	0.05
Maximum	26491.16
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	48.2 KiB

Quantile statistics

Minimum	0.05
5-th percentile	50.85
Q1	131.625
median	315.8
Q3	883.575
95-th percentile	3226.49
Maximum	26491.16
Range	26491.11
Interquartile range (IQR)	751.95

Descriptive statistics

Standard deviation	1553.908104
Coefficient of variation (CV)	1.836659896
Kurtosis	53.49357737
Mean	846.0510883
Median Absolute Deviation (MAD)	233.62
Skewness	5.757822692
Sum	5208290.5
Variance	2414630.395
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
846.0510883	110	1.8%
44	4	0.1%
58	4	0.1%
42	4	0.1%
61	4	0.1%
67	4	0.1%
36	4	0.1%
106	3	< 0.1%
184.93	3	< 0.1%
90.32	3	< 0.1%
Other values (5743)	6013	97.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.05	1	< 0.1%
0.27	1	< 0.1%
1	2	< 0.1%
1.71	1	< 0.1%
2	2	< 0.1%
2.1	1	< 0.1%
3.6	1	< 0.1%
4.74	1	< 0.1%
7.83	1	< 0.1%
8.86	1	< 0.1%

Value	Count	Frequency (%)
26491.16	1	< 0.1%
24349	1	< 0.1%
21786	1	< 0.1%
21355.5	1	< 0.1%
18142.5	1	< 0.1%
18112.42	1	< 0.1%
18100	1	< 0.1%
17530.44	1	< 0.1%
16201.3	1	< 0.1%
14503	1	< 0.1%

charity_care
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	4328
Distinct (%)	70.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4742004.031

Minimum	6
Maximum	595402233
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	48.2 KiB

Quantile statistics

Minimum	6
5-th percentile	17456.5
Q1	378153.75
median	2911040.5
Q3	4742004.031
95-th percentile	15624186.75
Maximum	595402233
Range	595402227
Interquartile range (IQR)	4363850.281

Descriptive statistics

Standard deviation	13844007.85
Coefficient of variation (CV)	2.919442445
Kurtosis	753.4402479
Mean	4742004.031
Median Absolute Deviation (MAD)	1966281.5
Skewness	22.06018491
Sum	2.919177682 × 10¹⁰
Variance	1.916565532 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4742004.031	1824	29.6%
81087	2	< 0.1%
37499	2	< 0.1%
133216	2	< 0.1%
77063	2	< 0.1%
11680	2	< 0.1%
21078	1	< 0.1%
13976	1	< 0.1%
2435852	1	< 0.1%
158385	1	< 0.1%
Other values (4318)	4318	70.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6	1	< 0.1%
61	1	< 0.1%
66	1	< 0.1%
111	1	< 0.1%
146	1	< 0.1%
155	1	< 0.1%
187	1	< 0.1%
195	1	< 0.1%
202	1	< 0.1%
213	1	< 0.1%

Value	Count	Frequency (%)
595402233	1	< 0.1%
434867979	1	< 0.1%
309261865	1	< 0.1%
204251414	1	< 0.1%
195261727	1	< 0.1%
188195501	1	< 0.1%
148955448	1	< 0.1%
142900541	1	< 0.1%
130968506	1	< 0.1%
118080108	1	< 0.1%

bad_dept_expence
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	4665
Distinct (%)	75.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12278282.72

Minimum	-185599
Maximum	423740576
Zeros	0
Zeros (%)	0.0%
Negative	3
Negative (%)	< 0.1%
Memory size	48.2 KiB

Quantile statistics

Minimum	-185599
5-th percentile	274692.5
Q1	2066813.75
median	8944558.5
Q3	12278282.72
95-th percentile	41207966.5
Maximum	423740576
Range	423926175
Interquartile range (IQR)	10211468.97

Descriptive statistics

Standard deviation	20281794.62
Coefficient of variation (CV)	1.65184294
Kurtosis	75.55241492
Mean	12278282.72
Median Absolute Deviation (MAD)	5659357
Skewness	6.734240105
Sum	7.558510843 × 10¹⁰
Variance	4.113511931 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12278282.72	1491	24.2%
864309	2	< 0.1%
2108068	1	< 0.1%
23942492	1	< 0.1%
3680954	1	< 0.1%
2992831	1	< 0.1%
34778277	1	< 0.1%
4916707	1	< 0.1%
999500	1	< 0.1%
6094845	1	< 0.1%
Other values (4655)	4655	75.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-185599	1	< 0.1%
-64101	1	< 0.1%
-38165	1	< 0.1%
1	1	< 0.1%
640	1	< 0.1%
826	1	< 0.1%
1326	1	< 0.1%
1364	1	< 0.1%
1698	1	< 0.1%
2248	1	< 0.1%

Value	Count	Frequency (%)
423740576	1	< 0.1%
310322511	1	< 0.1%
305383951	1	< 0.1%
285191231	1	< 0.1%
277352666	1	< 0.1%
274663265	1	< 0.1%
224137244	1	< 0.1%
223231071	1	< 0.1%
213578727	1	< 0.1%
197846042	1	< 0.1%

unreimbursed_and_uncompensated
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	4728
Distinct (%)	76.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13968568.12

Minimum	-201594
Maximum	650380201
Zeros	0
Zeros (%)	0.0%
Negative	9
Negative (%)	0.1%
Memory size	48.2 KiB

Quantile statistics

Minimum	-201594
5-th percentile	410630.75
Q1	2307436.25
median	9441104.5
Q3	13968568.12
95-th percentile	45634426.25
Maximum	650380201
Range	650581795
Interquartile range (IQR)	11661131.87

Descriptive statistics

Standard deviation	27594930.94
Coefficient of variation (CV)	1.975501763
Kurtosis	168.3479459
Mean	13968568.12
Median Absolute Deviation (MAD)	5950366.5
Skewness	10.39342304
Sum	8.599050535 × 10¹⁰
Variance	7.614802138 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13968568.12	1429	23.2%
2555902	1	< 0.1%
2206136	1	< 0.1%
53123294	1	< 0.1%
32344076	1	< 0.1%
1920037	1	< 0.1%
7099204	1	< 0.1%
5067595	1	< 0.1%
94713291	1	< 0.1%
2053337	1	< 0.1%
Other values (4718)	4718	76.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-201594	1	< 0.1%
-36979	1	< 0.1%
-22902	1	< 0.1%
-20024	1	< 0.1%
-4854	1	< 0.1%
-3323	1	< 0.1%
-2837	1	< 0.1%
-2387	1	< 0.1%
-971	1	< 0.1%
159	1	< 0.1%

Value	Count	Frequency (%)
650380201	1	< 0.1%
643730587	1	< 0.1%
575460014	1	< 0.1%
453852196	1	< 0.1%
388848053	1	< 0.1%
383755750	1	< 0.1%
357941490	1	< 0.1%
343992681	1	< 0.1%
333706197	1	< 0.1%
333072420	1	< 0.1%

Total Costs
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	6080
Distinct (%)	98.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	141764161.4

Minimum	632028
Maximum	4919290757
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	48.2 KiB

Quantile statistics

Minimum	632028
5-th percentile	6914528.5
Q1	17963261.25
median	45649883
Q3	147810674.5
95-th percentile	572705641.8
Maximum	4919290757
Range	4918658729
Interquartile range (IQR)	129847413.2

Descriptive statistics

Standard deviation	264901400.5
Coefficient of variation (CV)	1.868606268
Kurtosis	49.41625786
Mean	141764161.4
Median Absolute Deviation (MAD)	34639626.5
Skewness	5.413951667
Sum	8.727001773 × 10¹¹
Variance	7.017275199 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
141764161.4	77	1.3%
20709339	1	< 0.1%
187350043	1	< 0.1%
48409782	1	< 0.1%
25777777	1	< 0.1%
27612508	1	< 0.1%
77395342	1	< 0.1%
72702847	1	< 0.1%
115000049	1	< 0.1%
13281970	1	< 0.1%
Other values (6070)	6070	98.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
632028	1	< 0.1%
757558	1	< 0.1%
913314	1	< 0.1%
1007624	1	< 0.1%
1045317	1	< 0.1%
1048720	1	< 0.1%
1099926	1	< 0.1%
1118662	1	< 0.1%
1151609	1	< 0.1%
1216663	1	< 0.1%

Value	Count	Frequency (%)
4919290757	1	< 0.1%
4062019541	1	< 0.1%
3231950367	1	< 0.1%
2969483959	1	< 0.1%
2905410117	1	< 0.1%
2789871491	1	< 0.1%
2745690967	1	< 0.1%
2736118492	1	< 0.1%
2712233864	1	< 0.1%
2577935413	1	< 0.1%

outpatient_inpatient_charges
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	6079
Distinct (%)	98.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	639890533.6

Minimum	12943
Maximum	2.200093212 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	48.2 KiB

Quantile statistics

Minimum	12943
5-th percentile	8401288
Q1	39884646.5
median	141857623.5
Q3	684546975.5
95-th percentile	2889180742
Maximum	2.200093212 × 10¹⁰
Range	2.200091918 × 10¹⁰
Interquartile range (IQR)	644662329

Descriptive statistics

Standard deviation	1290221904
Coefficient of variation (CV)	2.016316598
Kurtosis	53.94126463
Mean	639890533.6
Median Absolute Deviation (MAD)	125794113.5
Skewness	5.627980862
Sum	3.939166125 × 10¹²
Variance	1.664672561 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
639890533.6	78	1.3%
1908466254	1	< 0.1%
6934607057	1	< 0.1%
900381817	1	< 0.1%
791331536	1	< 0.1%
1934985295	1	< 0.1%
23156373	1	< 0.1%
78994052	1	< 0.1%
110451523	1	< 0.1%
81325580	1	< 0.1%
Other values (6069)	6069	98.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12943	1	< 0.1%
20019	1	< 0.1%
25000	1	< 0.1%
35301	1	< 0.1%
35546	1	< 0.1%
38031	1	< 0.1%
38430	1	< 0.1%
39496	1	< 0.1%
43290	1	< 0.1%
50524	1	< 0.1%

Value	Count	Frequency (%)
2.200093212 × 10¹⁰	1	< 0.1%
1.934691589 × 10¹⁰	1	< 0.1%
1.862045123 × 10¹⁰	1	< 0.1%
1.841550679 × 10¹⁰	1	< 0.1%
1.819002621 × 10¹⁰	1	< 0.1%
1.597517982 × 10¹⁰	1	< 0.1%
1.333779326 × 10¹⁰	1	< 0.1%
1.318971083 × 10¹⁰	1	< 0.1%
1.291380902 × 10¹⁰	1	< 0.1%
1.199756447 × 10¹⁰	1	< 0.1%

total_salaries
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	4003
Distinct (%)	65.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	86947778.94

Minimum	2
Maximum	2748795093
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	48.2 KiB

Quantile statistics

Minimum	2
5-th percentile	5676598
Q1	26517399.75
median	86947778.94
Q3	86947778.94
95-th percentile	245171451.5
Maximum	2748795093
Range	2748795091
Interquartile range (IQR)	60430379.19

Descriptive statistics

Standard deviation	120786031.9
Coefficient of variation (CV)	1.389179038
Kurtosis	102.930067
Mean	86947778.94
Median Absolute Deviation (MAD)	34932962.44
Skewness	7.710365374
Sum	5.352505271 × 10¹¹
Variance	1.458926549 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
86947778.94	2154	35.0%
98566137	1	< 0.1%
24638436	1	< 0.1%
52080944	1	< 0.1%
46837908	1	< 0.1%
48630870	1	< 0.1%
71655243	1	< 0.1%
3451624	1	< 0.1%
37400149	1	< 0.1%
254457828	1	< 0.1%
Other values (3993)	3993	64.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	1	< 0.1%
126561	1	< 0.1%
469660	1	< 0.1%
526707	1	< 0.1%
670131	1	< 0.1%
675897	1	< 0.1%
705880	1	< 0.1%
714997	1	< 0.1%
769289	1	< 0.1%
782535	1	< 0.1%

Value	Count	Frequency (%)
2748795093	1	< 0.1%
2375307613	1	< 0.1%
1906822146	1	< 0.1%
1861278803	1	< 0.1%
1577426628	1	< 0.1%
1483430765	1	< 0.1%
1446544123	1	< 0.1%
1422350216	1	< 0.1%
1371317899	1	< 0.1%
1360771475	1	< 0.1%

Contract Labor
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	3054
Distinct (%)	49.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3988528.353

Minimum	118
Maximum	272713537
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	48.2 KiB

Quantile statistics

Minimum	118
5-th percentile	118361.5
Q1	1382238
median	3988528.353
Q3	3988528.353
95-th percentile	8278310
Maximum	272713537
Range	272713419
Interquartile range (IQR)	2606290.353

Descriptive statistics

Standard deviation	7564355.414
Coefficient of variation (CV)	1.896527928
Kurtosis	365.7203123
Mean	3988528.353
Median Absolute Deviation (MAD)	0
Skewness	15.06330879
Sum	2.455338054 × 10¹⁰
Variance	5.721947283 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3988528.353	3100	50.4%
81435	3	< 0.1%
60334	2	< 0.1%
513335	1	< 0.1%
1121113	1	< 0.1%
13354	1	< 0.1%
1266936	1	< 0.1%
977529	1	< 0.1%
232094	1	< 0.1%
476475	1	< 0.1%
Other values (3044)	3044	49.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
118	1	< 0.1%
159	1	< 0.1%
179	1	< 0.1%
300	1	< 0.1%
580	1	< 0.1%
600	1	< 0.1%
748	1	< 0.1%
766	1	< 0.1%
788	1	< 0.1%
917	1	< 0.1%

Value	Count	Frequency (%)
272713537	1	< 0.1%
154123720	1	< 0.1%
151975787	1	< 0.1%
127717567	1	< 0.1%
124992861	1	< 0.1%
109537998	1	< 0.1%
103500539	1	< 0.1%
101915236	1	< 0.1%
101158696	1	< 0.1%
95211661	1	< 0.1%

cash
Real number (ℝ)

HIGH CORRELATION

Distinct	5536
Distinct (%)	89.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16975543.01

Minimum	-2512769971
Maximum	4076539300
Zeros	0
Zeros (%)	0.0%
Negative	749
Negative (%)	12.2%
Memory size	48.2 KiB

Quantile statistics

Minimum	-2512769971
5-th percentile	-297579.5
Q1	38132.75
median	1741997.5
Q3	12481011.25
95-th percentile	61981390.5
Maximum	4076539300
Range	6589309271
Interquartile range (IQR)	12442878.5

Descriptive statistics

Standard deviation	100872601.1
Coefficient of variation (CV)	5.942231184
Kurtosis	588.0049988
Mean	16975543.01
Median Absolute Deviation (MAD)	1791168
Skewness	13.6303853
Sum	1.045014428 × 10¹¹
Variance	1.017528164 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16975543.01	494	8.0%
584887000	11	0.2%
500	10	0.2%
200	8	0.1%
1000	8	0.1%
2000	6	0.1%
300	5	0.1%
1800	4	0.1%
22365541	4	0.1%
2500	4	0.1%
Other values (5526)	5602	91.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2512769971	1	< 0.1%
-1155681285	1	< 0.1%
-934023371	1	< 0.1%
-396039226	1	< 0.1%
-359919000	1	< 0.1%
-291171983	1	< 0.1%
-268598532	1	< 0.1%
-259305692	1	< 0.1%
-237253015	1	< 0.1%
-207864268	1	< 0.1%

Value	Count	Frequency (%)
4076539300	1	< 0.1%
2294296719	1	< 0.1%
1897712074	1	< 0.1%
1879253269	1	< 0.1%
1189602607	1	< 0.1%
1079660000	1	< 0.1%
949719033	1	< 0.1%
921944653	1	< 0.1%
864780007	1	< 0.1%
814049000	1	< 0.1%

account_receivable
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	5755
Distinct (%)	93.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	62822563.37

Minimum	-178045756
Maximum	3711121305
Zeros	0
Zeros (%)	0.0%
Negative	31
Negative (%)	0.5%
Memory size	48.2 KiB

Quantile statistics

Minimum	-178045756
5-th percentile	1374058.25
Q1	4842519.5
median	17184334.5
Q3	62822563.37
95-th percentile	258486440.2
Maximum	3711121305
Range	3889167061
Interquartile range (IQR)	57980043.87

Descriptive statistics

Standard deviation	151605938.1
Coefficient of variation (CV)	2.413240243
Kurtosis	113.7513275
Mean	62822563.37
Median Absolute Deviation (MAD)	14856594.5
Skewness	8.255001184
Sum	3.867357001 × 10¹¹
Variance	2.298436046 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
62822563.37	362	5.9%
1504053000	10	0.2%
31439664	4	0.1%
661118422	3	< 0.1%
16104253	3	< 0.1%
226400237	3	< 0.1%
755087037	3	< 0.1%
260788528	2	< 0.1%
689589203	2	< 0.1%
242372141	2	< 0.1%
Other values (5745)	5762	93.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-178045756	1	< 0.1%
-82540523	1	< 0.1%
-74589046	1	< 0.1%
-9915948	1	< 0.1%
-5972745	1	< 0.1%
-5877484	1	< 0.1%
-5665747	1	< 0.1%
-3959322	1	< 0.1%
-3479685	1	< 0.1%
-3054943	1	< 0.1%

Value	Count	Frequency (%)
3711121305	1	< 0.1%
2664421466	1	< 0.1%
2503684998	1	< 0.1%
2111404205	1	< 0.1%
1859093481	1	< 0.1%
1725816418	1	< 0.1%
1685141926	1	< 0.1%
1504053000	10	0.2%
1486260000	1	< 0.1%
1282357324	1	< 0.1%

assets
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	5840
Distinct (%)	94.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	259262816.9

Minimum	-236846363
Maximum	1.6733791 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	87
Negative (%)	1.4%
Memory size	48.2 KiB

Quantile statistics

Minimum	-236846363
5-th percentile	2731484.75
Q1	15841489.75
median	57550732.5
Q3	238516990.2
95-th percentile	959876342.2
Maximum	1.6733791 × 10¹⁰
Range	1.697063736 × 10¹⁰
Interquartile range (IQR)	222675500.5

Descriptive statistics

Standard deviation	911534202.2
Coefficient of variation (CV)	3.515869391
Kurtosis	206.0416239
Mean	259262816.9
Median Absolute Deviation (MAD)	51098019
Skewness	12.70837102
Sum	1.596021901 × 10¹²
Variance	8.308946017 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
259262816.9	278	4.5%
1.6732789 × 10¹⁰	10	0.2%
1	5	0.1%
253284762	4	0.1%
495656988	3	< 0.1%
147533714	3	< 0.1%
62044169	3	< 0.1%
573261475	3	< 0.1%
1278376395	2	< 0.1%
992407000	2	< 0.1%
Other values (5830)	5843	94.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-236846363	1	< 0.1%
-208783744	1	< 0.1%
-182349033	1	< 0.1%
-124315706	1	< 0.1%
-118053062	1	< 0.1%
-116667981	1	< 0.1%
-111738589	1	< 0.1%
-76998816	1	< 0.1%
-72904200	1	< 0.1%
-71893191	1	< 0.1%

Value	Count	Frequency (%)
1.6733791 × 10¹⁰	1	< 0.1%
1.6732789 × 10¹⁰	10	0.2%
1.2320504 × 10¹⁰	1	< 0.1%
1.106209504 × 10¹⁰	1	< 0.1%
9943995942	1	< 0.1%
9009657962	1	< 0.1%
8744231428	1	< 0.1%
7814039000	1	< 0.1%
7800775205	1	< 0.1%
6894016227	1	< 0.1%

account_payable
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	5747
Distinct (%)	93.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13835008.17

Minimum	-998726734
Maximum	2057275120
Zeros	0
Zeros (%)	0.0%
Negative	71
Negative (%)	1.2%
Memory size	48.2 KiB

Quantile statistics

Minimum	-998726734
5-th percentile	129800.75
Q1	752021.75
median	2791351
Q3	11237749
95-th percentile	44116112.5
Maximum	2057275120
Range	3056001854
Interquartile range (IQR)	10485727.25

Descriptive statistics

Standard deviation	84952677.67
Coefficient of variation (CV)	6.140413984
Kurtosis	317.1121513
Mean	13835008.17
Median Absolute Deviation (MAD)	2466727
Skewness	16.13918324
Sum	8.516831032 × 10¹⁰
Variance	7.216957444 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13835008.17	368	6.0%
1671124000	10	0.2%
3230716	4	0.1%
7640695	3	< 0.1%
73053667	3	< 0.1%
18690429	3	< 0.1%
38714761	3	< 0.1%
16715387	2	< 0.1%
53975387	2	< 0.1%
1253169	2	< 0.1%
Other values (5737)	5756	93.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-998726734	1	< 0.1%
-387616772	1	< 0.1%
-351201876	1	< 0.1%
-238969806	1	< 0.1%
-172284225	1	< 0.1%
-164802810	1	< 0.1%
-162828306	1	< 0.1%
-160258193	1	< 0.1%
-146297888	1	< 0.1%
-142152375	1	< 0.1%

Value	Count	Frequency (%)
2057275120	1	< 0.1%
1671124000	10	0.2%
1463230350	1	< 0.1%
1195620298	1	< 0.1%
902076971	1	< 0.1%
817269583	1	< 0.1%
789138971	1	< 0.1%
693509781	1	< 0.1%
632777881	1	< 0.1%
604066000	1	< 0.1%

discharge_payments
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2987
Distinct (%)	48.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1582825.034

Minimum	40
Maximum	85077269
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	48.2 KiB

Quantile statistics

Minimum	40
5-th percentile	16446.25
Q1	400015
median	1582825.034
Q3	1582825.034
95-th percentile	3482011
Maximum	85077269
Range	85077229
Interquartile range (IQR)	1182810.034

Descriptive statistics

Standard deviation	3101429.689
Coefficient of variation (CV)	1.959426735
Kurtosis	235.6678861
Mean	1582825.034
Median Absolute Deviation (MAD)	0
Skewness	12.55576571
Sum	9743870910
Variance	9.618866118 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1582825.034	3164	51.4%
2666	2	< 0.1%
30608	2	< 0.1%
185034	2	< 0.1%
178713	2	< 0.1%
2471	2	< 0.1%
133	2	< 0.1%
6518	1	< 0.1%
7754706	1	< 0.1%
246430	1	< 0.1%
Other values (2977)	2977	48.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
40	1	< 0.1%
88	1	< 0.1%
115	1	< 0.1%
133	2	< 0.1%
165	1	< 0.1%
219	1	< 0.1%
283	1	< 0.1%
295	1	< 0.1%
326	1	< 0.1%
330	1	< 0.1%

Value	Count	Frequency (%)
85077269	1	< 0.1%
81514583	1	< 0.1%
58034251	1	< 0.1%
50833805	1	< 0.1%
49047601	1	< 0.1%
48760168	1	< 0.1%
45246407	1	< 0.1%
41337610	1	< 0.1%
40464971	1	< 0.1%
36902794	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	5894
Distinct (%)	95.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	670645341.5

Minimum	3
Maximum	2.200093212 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	48.2 KiB

Quantile statistics

Minimum	3
5-th percentile	11306111.25
Q1	46109167.5
median	174406566.5
Q3	690940487.5
95-th percentile	2919452819
Maximum	2.200093212 × 10¹⁰
Range	2.200093212 × 10¹⁰
Interquartile range (IQR)	644831320

Descriptive statistics

Standard deviation	1319793004
Coefficient of variation (CV)	1.967944787
Kurtosis	55.51887221
Mean	670645341.5
Median Absolute Deviation (MAD)	154781483.5
Skewness	5.743574918
Sum	4.128492722 × 10¹²
Variance	1.741853572 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
670645341.5	255	4.1%
356315732	4	0.1%
5844468101	2	< 0.1%
1572484505	2	< 0.1%
108324114	2	< 0.1%
965927621	2	< 0.1%
327602728	2	< 0.1%
45262644	1	< 0.1%
10429657	1	< 0.1%
788436501	1	< 0.1%
Other values (5884)	5884	95.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	1	< 0.1%
79683	1	< 0.1%
314601	1	< 0.1%
393938	1	< 0.1%
510769	1	< 0.1%
723233	1	< 0.1%
848561	1	< 0.1%
849536	1	< 0.1%
1068528	1	< 0.1%
1172704	1	< 0.1%

Value	Count	Frequency (%)
2.200093212 × 10¹⁰	1	< 0.1%
2.088095388 × 10¹⁰	1	< 0.1%
1.867724521 × 10¹⁰	1	< 0.1%
1.819002621 × 10¹⁰	1	< 0.1%
1.816561094 × 10¹⁰	1	< 0.1%
1.701736925 × 10¹⁰	1	< 0.1%
1.527025447 × 10¹⁰	1	< 0.1%
1.450204598 × 10¹⁰	1	< 0.1%
1.3337794 × 10¹⁰	1	< 0.1%
1.318971083 × 10¹⁰	1	< 0.1%

net_income
Real number (ℝ)

HIGH CORRELATION

Distinct	6054
Distinct (%)	98.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7452477.288

Minimum	-1098320439
Maximum	1623850983
Zeros	0
Zeros (%)	0.0%
Negative	2231
Negative (%)	36.2%
Memory size	48.2 KiB

Quantile statistics

Minimum	-1098320439
5-th percentile	-24196725
Q1	-1111740.75
median	1315531.5
Q3	9735268.5
95-th percentile	69079055.25
Maximum	1623850983
Range	2722171422
Interquartile range (IQR)	10847009.25

Descriptive statistics

Standard deviation	75697267.26
Coefficient of variation (CV)	10.15732948
Kurtosis	127.0619593
Mean	7452477.288
Median Absolute Deviation (MAD)	4355977.5
Skewness	0.5969321842
Sum	4.587745018 × 10¹⁰
Variance	5.730076271 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7452477.288	91	1.5%
-1	4	0.1%
11536337	4	0.1%
1	2	< 0.1%
460268	2	< 0.1%
856147	2	< 0.1%
24971164	2	< 0.1%
4686959	2	< 0.1%
228564404	2	< 0.1%
-36734516	1	< 0.1%
Other values (6044)	6044	98.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1098320439	1	< 0.1%
-1073015960	1	< 0.1%
-1048539003	1	< 0.1%
-1040645299	1	< 0.1%
-919906443	1	< 0.1%
-897444488	1	< 0.1%
-781990659	1	< 0.1%
-767230684	1	< 0.1%
-733721015	1	< 0.1%
-707787655	1	< 0.1%

Value	Count	Frequency (%)
1623850983	1	< 0.1%
1450938718	1	< 0.1%
1257839807	1	< 0.1%
1014667033	1	< 0.1%
834452809	1	< 0.1%
822576862	1	< 0.1%
554770767	1	< 0.1%
534091000	1	< 0.1%
526778650	1	< 0.1%
520030000	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	employee_payroll	charity_care	bad_dept_expence	unreimbursed_and_uncompensated	Total Costs	outpatient_inpatient_charges	total_salaries	Contract Labor	cash	account_receivable	assets	account_payable	discharge_payments	gross_revenue	net_income
0	76.72	4.016000e+03	263275.0	260140.0	1045317.0	2121751.0	526707.0	3.988528e+06	226139.0	5.825594e+06	2.132822e+06	2.190083e+06	1.582825e+06	2121751.0	82928.0
1	332.71	4.742004e+06	1984928.0	251208.0	7795912.0	65481775.0	3013251.0	6.027200e+04	1018957.0	3.743684e+07	3.601246e+07	3.194630e+06	2.971800e+04	65481775.0	-322251.0
2	96.58	4.742004e+06	500576.0	152458.0	1842485.0	6049571.0	1009269.0	3.988528e+06	-9342.0	8.593747e+06	3.324948e+06	1.253219e+06	1.582825e+06	6143875.0	-1026398.0
3	680.49	5.197140e+05	4922623.0	1649925.0	29173301.0	140077180.0	14212723.0	3.503400e+05	145422.0	1.418231e+08	1.110707e+08	3.467110e+06	1.145300e+05	141432373.0	-370783.0
4	1421.49	6.721210e+05	20492826.0	14922893.0	97713796.0	297655735.0	37400149.0	1.734240e+05	51676524.0	5.864628e+08	1.069469e+09	3.477631e+07	2.896290e+05	303053449.0	-11676899.0
5	1669.51	4.576250e+05	16864993.0	4613634.0	59841566.0	285037441.0	38470054.0	7.805400e+04	93360631.0	5.848935e+08	1.318474e+09	3.783514e+07	4.921980e+05	297971559.0	12567075.0
6	437.35	5.566820e+05	3460702.0	2990348.0	15296499.0	42444940.0	7143555.0	4.838520e+05	3413448.0	2.732609e+07	5.466237e+07	1.107780e+07	1.015060e+05	47327319.0	-4201467.0
7	1969.69	5.770730e+06	19226958.0	16412851.0	113004591.0	969581309.0	41951973.0	1.773586e+06	-2872444.0	4.303535e+07	4.720536e+08	1.383501e+07	7.202220e+05	971319903.0	-1493035.0
8	133.48	2.006680e+05	2105053.0	973516.0	9487650.0	53396615.0	3163934.0	4.366200e+04	59060.0	2.175000e+06	2.358849e+07	9.008750e+05	1.582825e+06	53396611.0	-1691066.0
9	51.13	2.025310e+05	3384272.0	825584.0	11786723.0	75537616.0	3498183.0	2.957500e+04	-41126.0	6.282256e+07	2.570701e+07	8.298070e+05	1.582825e+06	75577481.0	-1702022.0

Last rows

	employee_payroll	charity_care	bad_dept_expence	unreimbursed_and_uncompensated	Total Costs	outpatient_inpatient_charges	total_salaries	Contract Labor	cash	account_receivable	assets	account_payable	discharge_payments	gross_revenue	net_income
6146	55.35	1.792110e+05	1.868360e+05	2.804160e+05	11783019.0	1.228434e+07	8.694778e+07	3.988528e+06	4040020.0	2881168.0	10543315.0	585912.0	1.582825e+06	1.352454e+07	2468257.0
6147	91.81	8.613000e+04	5.040530e+05	3.496650e+05	24783186.0	4.103730e+07	8.694778e+07	3.988528e+06	9535623.0	8039644.0	24040157.0	2285201.0	1.582825e+06	4.319084e+07	4480785.0
6148	244.50	4.742004e+06	1.227828e+07	1.396857e+07	44920560.0	2.168232e+08	1.849893e+07	1.977958e+06	884.0	6744012.0	28519542.0	1725573.0	1.582825e+06	2.168232e+08	2272174.0
6149	213.70	4.742004e+06	1.227828e+07	1.396857e+07	34760071.0	2.036131e+08	1.579369e+07	1.413636e+06	-8909.0	9466289.0	24540830.0	2161061.0	1.582825e+06	2.036131e+08	95147.0
6150	145.28	4.742004e+06	1.227828e+07	1.396857e+07	24891599.0	3.756833e+07	1.097838e+07	3.988528e+06	3557227.0	3808778.0	8314830.0	295416.0	1.582825e+06	3.756833e+07	10609.0
6151	419.57	2.120514e+06	2.929861e+06	7.588803e+06	34745411.0	1.988503e+08	1.819819e+07	6.848500e+04	-1903584.0	19617834.0	40259388.0	3384628.0	5.978700e+04	1.988503e+08	-10990346.0
6152	23.49	4.742004e+06	4.960690e+05	5.315450e+05	6030642.0	5.945893e+06	8.694778e+07	3.988528e+06	822494.0	824593.0	4226664.0	446991.0	1.582825e+06	5.947596e+06	691836.0
6153	73.82	4.080000e+02	2.439600e+04	1.612230e+05	7986343.0	8.898392e+06	8.694778e+07	3.988528e+06	3113009.0	592595.0	11303103.0	276557.0	1.582825e+06	8.898367e+06	821364.0
6154	3765.55	1.190025e+07	1.235820e+08	5.583704e+07	690664225.0	2.772599e+09	2.463139e+08	4.657255e+06	109904000.0	119082000.0	918240000.0	65461000.0	3.234054e+06	2.772597e+09	79901000.0
6155	233.78	7.676580e+05	1.487747e+06	2.738189e+06	46371361.0	1.214401e+08	8.694778e+07	3.988528e+06	990740.0	19414577.0	30760542.0	1947600.0	1.582825e+06	1.351159e+08	5767902.0

Most frequently occurring

	employee_payroll	charity_care	bad_dept_expence	unreimbursed_and_uncompensated	Total Costs	outpatient_inpatient_charges	total_salaries	Contract Labor	cash	account_receivable	assets	account_payable	discharge_payments	gross_revenue	net_income	# duplicates
0	846.051088	4.742004e+06	1.227828e+07	1.396857e+07	1.417642e+08	6.398905e+08	8.694778e+07	3.988528e+06	1.697554e+07	6.282256e+07	2.592628e+08	1.383501e+07	1.582825e+06	6.706453e+08	7.452477e+06	77

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequently occurring